public marks

PUBLIC MARKS from "Xavier Lacot" with tags mysql & performance

2011

Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server

by 2 others
Using a MySQL "HandlerSocket" plugin, Yoshinori Matsunobu achieved a 750K requests per second on a normal box, which was slightly more performant than with a memcached server

2009

Jet Profiler for MySQL

by 2 others
"Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQL database server". I love the Query ratings feature and the live query observation - should replace the weak use of MySQL proxy.

2007

~jk ORDER BY RAND()

by 1 other
If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows.

Conseils pour l'amélioration des performances InnoDB

by 2 others
Quelques conseils pour améliorer les perfs InnoDB